/*
 * Copyright (c) 2006 Monsur Hossain

 * Permission is hereby granted, free of charge, to any person obtaining a 
 * copy of this software and associated documentation files (the 
 * "Software"), to deal in the Software without restriction, including 
 * without limitation the rights to use, copy, modify, merge, publish, 
 * distribute, sublicense, and/or sell copies of the Software, and to 
 * permit persons to whom the Software is furnished to do so, subject to 
 * the following conditions:

 * The above copyright notice and this permission notice shall be included 
 * in all copies or substantial portions of the Software.

 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS 
 * OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF 
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. 
 * IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY 
 * CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, 
 * TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE 
 * SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */
using System;
using System.Collections.Generic;
using System.Text;

namespace RhapsodyNET
{
    /// <summary>
    /// Helper classes for interacting with an SQLite database
    /// </summary>
    internal class SqliteHelper
    {
        // datetimes in SQLite are in the following format
        private static string dateFormatter = "yyyyMMddTHHmmss";

        /// <summary>
        /// Convert a date to an SQLite date string
        /// </summary>
        public static string DateToString(DateTime inputDate)
        {
            return inputDate.ToString(dateFormatter);
        }

        /// <summary>
        /// Convert an SQLite date string to a .NET DateTime object
        /// </summary>
        public static DateTime StringToDate(string inputString)
        {
            if (inputString.Length == 0)
                return DateTime.MinValue;
            return DateTime.ParseExact(inputString, dateFormatter, null);
        }
    }
}
